资产概述
概述
id资产管理
select
c.name as win_name, c.isactive,
b.name as tab_name,b.isactive,
a.name as tab_name_trl,
t.tablename, t.isactive from ad_tab_trl a
join ad_tab b on a.ad_tab_id=b.ad_tab_id
join ad_window c on c.ad_window_id=b.ad_window_id
join ad_table t on b.ad_table_id=t.ad_table_id and t.tablename ~'^A_'
order by 1 , b.seqno
术语